Notes/Domino Fix List
 |  |
| SPR # PJAN4DCHWV | Fixed in 5.0.3 release |  |
Product Area: Other Technical Area: LS:DO Platform: Cross Platform
SPR# PJAN4DCHWV - Fix a crash which occurred when doing an SQL INSERT of a long string.
Technote Number: 1096082
Problem:
This issue was reported to Lotus Software Quality Engineering and has been
addressed in Notes/Domino 4.6.7 and 5.0.3.
Excerpt from the Fix Lists for Lotus Notes and Lotus Domino Release 4.6.7 and
5.0.3 QMR's:
LS:DO
SPR# PJAN4DCHWV - Fix a crash which occurred when doing an SQL INSERT of a long
string. [4.6.7]
You can work around the issue, using the SetValue and UpdateRow approach. The
following script will update the back-end field with the 1500-character string
and does not cause a crash.
'Same code leading up to the sqlStatement line.
sqlStatement = "SELECT * FROM LONGSTRING WHERE ID = '1' "
Qry.SQL = sqlStatement
Set res.Query = Qry
status = res.Execute
status = res.setvalue("LSTRING",newDesc)
status = res.updaterow
res.close(DB_CLOSE)
con.DisConnect
Supporting Information:
The following code causes Notes to crash on the qry.sql= line:
Dim Con As New ODBCConnection
Dim Qry As New ODBCQuery
Dim res As New ODBCResultSet
newDesc = "A string of 1500 characters"
Con.ConnectTo("DSN")
Set Qry.Connection = Con
sqlStatement = "UPDATE LONGSTRING SET LSTRING = '" + newDesc+"' WHERE ID =
'1'"
Qry.SQL = sqlStatement 'This line causes the crash.
Set res.Query = Qry
status = res.Execute
res.close(DB_CLOSE)
con.DisConnect
Note that the above script does not cause a crash when the newDesc string
variable is set to a 500-character string.
More >
Last Modified on 11/16/2000
Go back
|